Estimated Equation
## [1] "LnTrendedPrice = 6.08514859421406 + 0.292299138797382 * BaseLandC + 0.331221399903332 * TotalRcnC - 0.0978292792914997 * AgeC_Ren + 0.0306832003659105 * GoodYN + 0.110260453251257 * VGoodYN"
Descriptive Statistics
|
Variable
|
Count
|
Mean
|
Std. Dev.
|
Std. Error
|
Min
|
Max
|
|
LnTrendedPrice
|
1101
|
13.87328
|
0.29770
|
0.00897
|
11.74077
|
14.95086
|
|
BaseLandC
|
1101
|
12.94630
|
0.13412
|
0.00404
|
12.35879
|
14.37284
|
|
TotalRcnC
|
1101
|
12.89035
|
0.42157
|
0.01270
|
11.82774
|
14.52108
|
|
AgeC_Ren
|
1101
|
2.85647
|
0.98734
|
0.02976
|
1.09861
|
4.49981
|
|
GoodYN
|
1101
|
0.28429
|
0.45128
|
0.01360
|
0.00000
|
1.00000
|
|
VGoodYN
|
1101
|
0.04632
|
0.21028
|
0.00634
|
0.00000
|
1.00000
|
Run Summary Report
|
Dependent Variable
|
LnTrendedPrice
|
|
Number of Independent Variables
|
5
|
|
R Squared
|
0.4205255
|
|
Adjusted R-Squared
|
0.4178795
|
|
Residual Standard Error
|
0.2271343
|
Correlation Matrix
Coefficients T-Tests and Confidence Intervals
|
Variables
|
Regression Coefficient
|
Std. Error
|
T-Statistic to Test (H0)
|
Prob Level
|
Reject H0 at 5%?
|
Lower 95% Confidence Limit
|
Upper 95% Confidence Limit
|
|
(Intercept)
|
6.08514859
|
0.68896870
|
8.832257
|
0.00000000
|
Yes
|
4.73330051
|
7.43699668
|
|
BaseLandC
|
0.29229914
|
0.05171331
|
5.652300
|
0.00000002
|
Yes
|
0.19083076
|
0.39376752
|
|
TotalRcnC
|
0.33122140
|
0.01843097
|
17.970912
|
0.00000000
|
Yes
|
0.29505738
|
0.36738542
|
|
AgeC_Ren
|
-0.09782928
|
0.00947144
|
-10.328873
|
0.00000000
|
Yes
|
-0.11641350
|
-0.07924506
|
|
GoodYN
|
0.03068320
|
0.01978612
|
1.550744
|
0.12125210
|
No
|
-0.00813980
|
0.06950620
|
|
VGoodYN
|
0.11026045
|
0.03603025
|
3.060219
|
0.00226559
|
Yes
|
0.03956431
|
0.18095660
|
Analysis of Variance Detail (ANOVA)
|
Variables
|
Df
|
Sum of Squares
|
Mean Sq
|
F value
|
Prob Level
|
|
BaseLandC
|
1
|
1.45201
|
1.45201
|
28.14515
|
0.00000
|
|
TotalRcnC
|
1
|
32.65902
|
32.65902
|
633.04968
|
0.00000
|
|
AgeC_Ren
|
1
|
6.38822
|
6.38822
|
123.82668
|
0.00000
|
|
GoodYN
|
1
|
0.01324
|
0.01324
|
0.25655
|
0.61260
|
|
VGoodYN
|
1
|
0.48314
|
0.48314
|
9.36494
|
0.00227
|
|
Error
|
1095
|
56.49103
|
0.05159
|
NA
|
NA
|
R-Squared Report
|
Independent Variable (I.V.)
|
Stepwise R-Squared
|
Stepwise Mallow’s Cp
|
Stepwise RMSE
|
|
TotalRcnC
|
0.34123
|
147.83329
|
0.24173
|
|
AgeC_Ren
|
0.39916
|
40.37896
|
0.23097
|
|
BaseLandC
|
0.41543
|
11.62149
|
0.22792
|
|
VGoodYN
|
0.41925
|
6.40481
|
0.22728
|
|
GoodYN
|
0.42053
|
6.00000
|
0.22713
|
Variable Omission Report
|
Variable
|
R-Sq if I.V. Omitted
|
Mallow’s Cp if I.V. Omitted
|
|
BaseLandC
|
0.40362
|
35.94850
|
|
TotalRcnC
|
0.24962
|
326.95367
|
|
AgeC_Ren
|
0.36407
|
110.68562
|
|
GoodYN
|
0.41925
|
6.40481
|
|
VGoodYN
|
0.41557
|
13.36494
|
Multicollinearity Table
|
Variables
|
Tolerance
|
Variance Inflation Factor (VIF)
|
|
BaseLandC
|
0.9749181
|
1.025727
|
|
TotalRcnC
|
0.7768562
|
1.287240
|
|
AgeC_Ren
|
0.5362976
|
1.864636
|
|
GoodYN
|
0.5882485
|
1.699962
|
|
VGoodYN
|
0.8170687
|
1.223887
|
Normality Output
|
Test Name
|
Test Statistic
|
Prob Level
|
|
Shapiro-Wilk normality test
|
0.84437
|
0
|
|
Anderson - Darling Normality Test
|
28.68604
|
0
|
|
D’Agostino Chi-Squared Test
|
674.02457
|
0
|
|
D’Agostino Skewness Test
|
-19.59936
|
0
|
|
D’AGostino Kurtosis Test
|
17.02615
|
0
|
Residual of Y vs Predicted Y
Residual of Y vs Sale Price
Fitted Y vs Fitted X Plots
Component + Residual Plots